Class TXLSDbRead5

DescriptionHierarchyFieldsMethodsProperties

Unit

Declaration

type TXLSDbRead5 = class(TComponent)

Description

Component for importing data sets (TDataset) into a XLSReadWriteII component.

Hierarchy

  • TComponent
  • TXLSDbRead5

Overview

Methods

Public constructor Create(AOwner: TComponent); override;
Public destructor Destroy; override;
Public procedure Read;

Properties

Public property CellColors[Index:integer]: TXc12IndexColor read GetCellColors write SetCellColors;
Published property Column: byte read FCol write FCol;
Published property Dataset: TDataset read FDataset write FDataset;
Published property ExcludeFields: TStrings read FExcludeFields write SetExcludeFields;
Published property IncludeFields: TStrings read FIncludeFields write SetIncludeFields;
Published property IncludeFieldnames: boolean read FIncludeFieldnames write FIncludeFieldnames;
Published property IndentDetailTables: boolean read FIndentDetailTables write FIndentDetailTables;
Published property ReadDetailTables: boolean read FReadDetailTables write FReadDetailTables;
Published property FormatCells: boolean read FFormatCells write FFormatCells;
Published property Row: word read FRow write FRow;
Published property Sheet: integer read FSheet write FSheet;
Published property XLS: TXLSReadWriteII5 read FXLS write SetXLS;
Published property OnDbCell: TXLSDbCellEvent read FDbCellEvent write FDbCellEvent;
Published property OnDbRecord: TXLSDbRecordEvent read FDbRecordEvent write FDbRecordEvent;

Description

Methods

Public constructor Create(AOwner: TComponent); override;

˜exclude

Public destructor Destroy; override;

˜exclude

Public procedure Read;

Starts reading the source ˜[link Dataset].

Properties

Public property CellColors[Index:integer]: TXc12IndexColor read GetCellColors write SetCellColors;

Cell colors used when ˜[link FormatCells] is on. The frist index (#0) is for the master table, the following for detail tables. There can be 8 levels, index 0..7

Published property Column: byte read FCol write FCol;

Current column where the cells are inserted.

Published property Dataset: TDataset read FDataset write FDataset;

Source data set.

Published property ExcludeFields: TStrings read FExcludeFields write SetExcludeFields;

List of field names in the data set that not shall be imported.

Published property IncludeFields: TStrings read FIncludeFields write SetIncludeFields;

List of field names in the data set that shall be imported. If the list is empty, all fileds are included.

Published property IncludeFieldnames: boolean read FIncludeFieldnames write FIncludeFieldnames;

Write the names of the fields on the first row.

Published property IndentDetailTables: boolean read FIndentDetailTables write FIndentDetailTables;

When True, detail tables are shifted one column to the right for each level.

Published property ReadDetailTables: boolean read FReadDetailTables write FReadDetailTables;

When True, detail tables are read. When False, only the master table is read.

Published property FormatCells: boolean read FFormatCells write FFormatCells;

When True, the color of the inserted cells are set according to the colors in ˜[link CellColors]

Published property Row: word read FRow write FRow;

Current row where the cells are inserted.

Published property Sheet: integer read FSheet write FSheet;

Index to the current sheet where the cells are inserted.

Published property XLS: TXLSReadWriteII5 read FXLS write SetXLS;

The destination TXLSReadWriteII2 object.

Published property OnDbCell: TXLSDbCellEvent read FDbCellEvent write FDbCellEvent;

Event fired when a cell is inserted. The event is fired after data is written to the cell. Use this event for user formatting of the cells, or changing the destination on where the cells are inserted.

Published property OnDbRecord: TXLSDbRecordEvent read FDbRecordEvent write FDbRecordEvent;

Event fired when a record is read.


Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48